Pandas Profiling Report

Dataset statistics

Number of variables	28
Number of observations	14606
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.8 MiB
Average record size in memory	347.0 B

Variable types

Categorical	3
Numeric	20
DateTime	4
Boolean	1

Alerts

`id` has a high cardinality: 14606 distinct values	High cardinality
`cons_12m` is highly overall correlated with `cons_last_month` and 2 other fields	High correlation
`cons_gas_12m` is highly overall correlated with `nb_prod_act`	High correlation
`cons_last_month` is highly overall correlated with `cons_12m` and 2 other fields	High correlation
`forecast_cons_12m` is highly overall correlated with `cons_12m` and 3 other fields	High correlation
`forecast_cons_year` is highly overall correlated with `cons_last_month` and 3 other fields	High correlation
`forecast_meter_rent_12m` is highly overall correlated with `forecast_price_energy_off_peak` and 3 other fields	High correlation
`forecast_price_energy_off_peak` is highly overall correlated with `forecast_meter_rent_12m` and 2 other fields	High correlation
`forecast_price_energy_peak` is highly overall correlated with `forecast_meter_rent_12m` and 2 other fields	High correlation
`forecast_price_pow_off_peak` is highly overall correlated with `forecast_meter_rent_12m` and 3 other fields	High correlation
`imp_cons` is highly overall correlated with `cons_last_month` and 3 other fields	High correlation
`margin_gross_pow_ele` is highly overall correlated with `margin_net_pow_ele`	High correlation
`margin_net_pow_ele` is highly overall correlated with `margin_gross_pow_ele`	High correlation
`nb_prod_act` is highly overall correlated with `cons_gas_12m`	High correlation
`net_margin` is highly overall correlated with `cons_12m` and 3 other fields	High correlation
`num_years_antig` is highly overall correlated with `start_year`	High correlation
`pow_max` is highly overall correlated with `forecast_meter_rent_12m` and 3 other fields	High correlation
`start_year` is highly overall correlated with `num_years_antig`	High correlation
`churn` is highly imbalanced (54.0%)	Imbalance
`end_year` is highly imbalanced (65.5%)	Imbalance
`net_margin` is highly skewed (γ1 = 36.56951466)	Skewed
`id` is uniformly distributed	Uniform
`id` has unique values	Unique
`channel_sales` has 3725 (25.5%) zeros	Zeros
`cons_gas_12m` has 11994 (82.1%) zeros	Zeros
`cons_last_month` has 4983 (34.1%) zeros	Zeros
`forecast_cons_12m` has 306 (2.1%) zeros	Zeros
`forecast_cons_year` has 6148 (42.1%) zeros	Zeros
`forecast_discount_energy` has 14094 (96.5%) zeros	Zeros
`forecast_meter_rent_12m` has 725 (5.0%) zeros	Zeros
`forecast_price_energy_peak` has 7021 (48.1%) zeros	Zeros
`imp_cons` has 6169 (42.2%) zeros	Zeros
`margin_gross_pow_ele` has 157 (1.1%) zeros	Zeros
`margin_net_pow_ele` has 157 (1.1%) zeros	Zeros
`net_margin` has 185 (1.3%) zeros	Zeros

Reproduction

Analysis started	2023-07-08 12:42:02.844357
Analysis finished	2023-07-08 12:42:49.393034
Duration	46.55 seconds
Software version	pandas-profiling vv3.6.2
Download configuration	config.json

id
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	14606
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

24011ae4ebbe3035111d65fa7c15bc57	1
2fae70276cd7a4874a2aefcd68d5a184	1
a7a9dac0ffc2ad56c66a1b08d53d0e51	1
6cfbce2099a4163ea4fe422fb28829ea	1
4289e929ecd35a0754e697feb24a091b	1
Other values (14601)	14601

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	467392
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14606 ?
Unique (%)	100.0%

Sample

1st row	24011ae4ebbe3035111d65fa7c15bc57
2nd row	d29c2c54acc38ff3c0614d0a653813dd
3rd row	764c75f661154dac3a6c254cd082ea7d
4th row	bba03439a292a1e166f80264c16191cb
5th row	149d57cf92fc41cf94415803a877cb4b

Common Values

Value	Count	Frequency (%)
24011ae4ebbe3035111d65fa7c15bc57	1	< 0.1%
2fae70276cd7a4874a2aefcd68d5a184	1	< 0.1%
a7a9dac0ffc2ad56c66a1b08d53d0e51	1	< 0.1%
6cfbce2099a4163ea4fe422fb28829ea	1	< 0.1%
4289e929ecd35a0754e697feb24a091b	1	< 0.1%
1a48dbd5cc49dc74542bd008a684e247	1	< 0.1%
ae2699b4f74ce6e5819ee4f16049c03d	1	< 0.1%
4be734763fa4f51371a161491ce4a8a8	1	< 0.1%
0659a0dae786fed9915a37df88302a83	1	< 0.1%
c961b41f4f388c1bd8d126c40d9703f5	1	< 0.1%
Other values (14596)	14596	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
24011ae4ebbe3035111d65fa7c15bc57	1	< 0.1%
26c7bba7d51f86a16109de505bcd4f52	1	< 0.1%
74ff037708f036de5745ce34d8d9d4df	1	< 0.1%
21860c2ff2d5df75503b230ce629c253	1	< 0.1%
764c75f661154dac3a6c254cd082ea7d	1	< 0.1%
bba03439a292a1e166f80264c16191cb	1	< 0.1%
149d57cf92fc41cf94415803a877cb4b	1	< 0.1%
1aa498825382410b098937d65c4ec26d	1	< 0.1%
7ab4bf4878d8f7661dfc20e9b8e18011	1	< 0.1%
01495c955be7ec5e7f3203406785aae0	1	< 0.1%
Other values (14596)	14596	99.9%

Most occurring characters

Value	Count	Frequency (%)
6	29453	6.3%
e	29432	6.3%
7	29400	6.3%
4	29381	6.3%
2	29375	6.3%
b	29313	6.3%
3	29297	6.3%
1	29257	6.3%
c	29210	6.2%
a	29169	6.2%
Other values (6)	174105	37.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	292239	62.5%
Lowercase Letter	175153	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	29453	10.1%
7	29400	10.1%
4	29381	10.1%
2	29375	10.1%
3	29297	10.0%
1	29257	10.0%
8	29153	10.0%
0	29090	10.0%
9	29012	9.9%
5	28821	9.9%

Lowercase Letter

Value	Count	Frequency (%)
e	29432	16.8%
b	29313	16.7%
c	29210	16.7%
a	29169	16.7%
d	29137	16.6%
f	28892	16.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	292239	62.5%
Latin	175153	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	29453	10.1%
7	29400	10.1%
4	29381	10.1%
2	29375	10.1%
3	29297	10.0%
1	29257	10.0%
8	29153	10.0%
0	29090	10.0%
9	29012	9.9%
5	28821	9.9%

Latin

Value	Count	Frequency (%)
e	29432	16.8%
b	29313	16.7%
c	29210	16.7%
a	29169	16.7%
d	29137	16.6%
f	28892	16.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	467392	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	29453	6.3%
e	29432	6.3%
7	29400	6.3%
4	29381	6.3%
2	29375	6.3%
b	29313	6.3%
3	29297	6.3%
1	29257	6.3%
c	29210	6.2%
a	29169	6.2%
Other values (6)	174105	37.3%

channel_sales
Real number (ℝ)

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2669451

Minimum	0
Maximum	7
Zeros	3725
Zeros (%)	25.5%
Negative	0
Negative (%)	0.0%
Memory size	57.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	4
95-th percentile	7
Maximum	7
Range	7
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.1832229
Coefficient of variation (CV)	0.66827658
Kurtosis	-0.85117678
Mean	3.2669451
Median Absolute Deviation (MAD)	1
Skewness	-0.31405343
Sum	47717
Variance	4.7664622
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
4	6754	46.2%
0	3725	25.5%
5	1843	12.6%
7	1375	9.4%
2	893	6.1%
6	11	0.1%
1	3	< 0.1%
3	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3725	25.5%
1	3	< 0.1%
2	893	6.1%
3	2	< 0.1%
4	6754	46.2%
5	1843	12.6%
6	11	0.1%
7	1375	9.4%

Value	Count	Frequency (%)
7	1375	9.4%
6	11	0.1%
5	1843	12.6%
4	6754	46.2%
3	2	< 0.1%
2	893	6.1%
1	3	< 0.1%
0	3725	25.5%

cons_12m
Real number (ℝ)

Distinct	11065
Distinct (%)	75.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	159220.29

Minimum	0
Maximum	6207104
Zeros	117
Zeros (%)	0.8%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1512.25
Q1	5674.75
median	14115.5
Q3	40763.75
95-th percentile	913771.75
Maximum	6207104
Range	6207104
Interquartile range (IQR)	35089

Descriptive statistics

Standard deviation	573465.26
Coefficient of variation (CV)	3.6017098
Kurtosis	42.689777
Mean	159220.29
Median Absolute Deviation (MAD)	10669
Skewness	5.9973081
Sum	2.3255715 × 10⁹
Variance	3.2886241 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	117	0.8%
2882597	27	0.2%
3329244	24	0.2%
1743025	18	0.1%
3926060	18	0.1%
6207104	18	0.1%
1722179	17	0.1%
2288838	17	0.1%
2503923	16	0.1%
963288	16	0.1%
Other values (11055)	14318	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	117	0.8%
1	2	< 0.1%
2	2	< 0.1%
3	4	< 0.1%
4	2	< 0.1%
5	1	< 0.1%
6	2	< 0.1%
7	3	< 0.1%
9	2	< 0.1%
10	4	< 0.1%

Value	Count	Frequency (%)
6207104	18	0.1%
5731448	14	0.1%
5322441	1	< 0.1%
5161456	4	< 0.1%
4939487	4	< 0.1%
4406520	14	0.1%
4306656	9	0.1%
4199490	5	< 0.1%
4100379	13	0.1%
4012564	2	< 0.1%

cons_gas_12m
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2112
Distinct (%)	14.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28092.375

Minimum	0
Maximum	4154590
Zeros	11994
Zeros (%)	82.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	75854
Maximum	4154590
Range	4154590
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	162973.06
Coefficient of variation (CV)	5.8013271
Kurtosis	126.33363
Mean	28092.375
Median Absolute Deviation (MAD)	0
Skewness	9.59753
Sum	4.1031723 × 10⁸
Variance	2.6560218 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11994	82.1%
976731	27	0.2%
867921	24	0.2%
41532	18	0.1%
1959386	18	0.1%
1192414	17	0.1%
475413	16	0.1%
468369	15	0.1%
1337056	14	0.1%
187578	13	0.1%
Other values (2102)	2450	16.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11994	82.1%
11	7	< 0.1%
12	2	< 0.1%
21	2	< 0.1%
32	1	< 0.1%
35	2	< 0.1%
36	1	< 0.1%
41	1	< 0.1%
43	2	< 0.1%
46	1	< 0.1%

Value	Count	Frequency (%)
4154590	2	< 0.1%
2813019	2	< 0.1%
2055098	2	< 0.1%
1959386	18	0.1%
1860052	4	< 0.1%
1859491	3	< 0.1%
1813943	1	< 0.1%
1711930	1	< 0.1%
1653924	2	< 0.1%
1542867	1	< 0.1%

cons_last_month
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4751
Distinct (%)	32.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16090.27

Minimum	0
Maximum	771203
Zeros	4983
Zeros (%)	34.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	792.5
Q3	3383
95-th percentile	82161.5
Maximum	771203
Range	771203
Interquartile range (IQR)	3383

Descriptive statistics

Standard deviation	64364.196
Coefficient of variation (CV)	4.0001937
Kurtosis	47.762991
Mean	16090.27
Median Absolute Deviation (MAD)	792.5
Skewness	6.391407
Sum	2.3501448 × 10⁸
Variance	4.1427498 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4983	34.1%
382647	27	0.2%
509826	24	0.2%
558120	18	0.1%
469210	18	0.1%
106161	18	0.1%
181187	17	0.1%
237044	17	0.1%
54281	16	0.1%
313018	16	0.1%
Other values (4741)	9452	64.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4983	34.1%
1	13	0.1%
2	5	< 0.1%
3	5	< 0.1%
4	4	< 0.1%
5	5	< 0.1%
6	2	< 0.1%
7	5	< 0.1%
8	5	< 0.1%
9	4	< 0.1%

Value	Count	Frequency (%)
771203	14	0.1%
760727	1	< 0.1%
612247	1	< 0.1%
558120	18	0.1%
509826	24	0.2%
507598	14	0.1%
479030	9	0.1%
469898	2	< 0.1%
469210	18	0.1%
456462	5	< 0.1%

date_activ
Date

Distinct	1796
Distinct (%)	12.3%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

Minimum	2003-05-09 00:00:00
Maximum	2014-09-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

date_end
Date

Distinct	368
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

Minimum	2016-01-28 00:00:00
Maximum	2017-06-13 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

date_modif_prod
Date

Distinct	2129
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

Minimum	2003-05-09 00:00:00
Maximum	2016-01-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

date_renewal
Date

Distinct	386
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	114.2 KiB

Minimum	2013-06-26 00:00:00
Maximum	2016-01-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

forecast_cons_12m
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	13993
Distinct (%)	95.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1868.6149

Minimum	0
Maximum	82902.83
Zeros	306
Zeros (%)	2.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	84.9175
Q1	494.995
median	1112.875
Q3	2401.79
95-th percentile	6127.095
Maximum	82902.83
Range	82902.83
Interquartile range (IQR)	1906.795

Descriptive statistics

Standard deviation	2387.5715
Coefficient of variation (CV)	1.2777226
Kurtosis	147.42668
Mean	1868.6149
Median Absolute Deviation (MAD)	752.955
Skewness	7.1558526
Sum	27292989
Variance	5700497.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	306	2.1%
0.15	6	< 0.1%
415.14	4	< 0.1%
0.45	3	< 0.1%
1539.37	3	< 0.1%
651.21	3	< 0.1%
442.74	3	< 0.1%
335.5	3	< 0.1%
0.3	3	< 0.1%
303.93	3	< 0.1%
Other values (13983)	14269	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	306	2.1%
0.1	1	< 0.1%
0.15	6	< 0.1%
0.18	1	< 0.1%
0.2	1	< 0.1%
0.3	3	< 0.1%
0.32	1	< 0.1%
0.33	1	< 0.1%
0.42	2	< 0.1%
0.45	3	< 0.1%

Value	Count	Frequency (%)
82902.83	1	< 0.1%
61357.17	1	< 0.1%
48412.58	1	< 0.1%
35789.29	1	< 0.1%
35312.21	1	< 0.1%
32174.47	1	< 0.1%
31347.11	1	< 0.1%
30533.99	1	< 0.1%
28375.76	1	< 0.1%
27618.39	1	< 0.1%

forecast_cons_year
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4218
Distinct (%)	28.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1399.7629

Minimum	0
Maximum	175375
Zeros	6148
Zeros (%)	42.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	314
Q3	1745.75
95-th percentile	5968.75
Maximum	175375
Range	175375
Interquartile range (IQR)	1745.75

Descriptive statistics

Standard deviation	3247.7863
Coefficient of variation (CV)	2.3202403
Kurtosis	653.73441
Mean	1399.7629
Median Absolute Deviation (MAD)	314
Skewness	16.58799
Sum	20444937
Variance	10548116
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6148	42.1%
1	13	0.1%
8	13	0.1%
7	11	0.1%
453	11	0.1%
2	9	0.1%
524	9	0.1%
310	9	0.1%
420	9	0.1%
173	9	0.1%
Other values (4208)	8365	57.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6148	42.1%
1	13	0.1%
2	9	0.1%
3	5	< 0.1%
4	8	0.1%
5	7	< 0.1%
6	5	< 0.1%
7	11	0.1%
8	13	0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
175375	1	< 0.1%
79127	1	< 0.1%
70180	1	< 0.1%
66643	1	< 0.1%
63969	1	< 0.1%
59460	1	< 0.1%
51604	1	< 0.1%
51336	1	< 0.1%
50106	1	< 0.1%
46491	1	< 0.1%

forecast_discount_energy
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.966726

Minimum	0
Maximum	30
Zeros	14094
Zeros (%)	96.5%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	30
Range	30
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.1082887
Coefficient of variation (CV)	5.2841122
Kurtosis	24.854712
Mean	0.966726
Median Absolute Deviation (MAD)	0
Skewness	5.1550983
Sum	14120
Variance	26.094613
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	14094	96.5%
30	260	1.8%
28	102	0.7%
24	83	0.6%
22	47	0.3%
25	7	< 0.1%
26	5	< 0.1%
19	2	< 0.1%
17	2	< 0.1%
23	2	< 0.1%
Other values (2)	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14094	96.5%
5	1	< 0.1%
10	1	< 0.1%
17	2	< 0.1%
19	2	< 0.1%
22	47	0.3%
23	2	< 0.1%
24	83	0.6%
25	7	< 0.1%
26	5	< 0.1%

Value	Count	Frequency (%)
30	260	1.8%
28	102	0.7%
26	5	< 0.1%
25	7	< 0.1%
24	83	0.6%
23	2	< 0.1%
22	47	0.3%
19	2	< 0.1%
17	2	< 0.1%
10	1	< 0.1%

forecast_meter_rent_12m
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3528
Distinct (%)	24.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.086871

Minimum	0
Maximum	599.31
Zeros	725
Zeros (%)	5.0%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.3325
Q1	16.18
median	18.795
Q3	131.03
95-th percentile	145.72
Maximum	599.31
Range	599.31
Interquartile range (IQR)	114.85

Descriptive statistics

Standard deviation	66.165783
Coefficient of variation (CV)	1.0488043
Kurtosis	4.4915214
Mean	63.086871
Median Absolute Deviation (MAD)	9.315
Skewness	1.5051479
Sum	921446.84
Variance	4377.9108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	725	5.0%
131.76	238	1.6%
18.32	162	1.1%
18.37	131	0.9%
129.61	103	0.7%
15.98	100	0.7%
131.38	78	0.5%
18.47	77	0.5%
16.26	76	0.5%
18.42	74	0.5%
Other values (3518)	12842	87.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	725	5.0%
0.09	1	< 0.1%
0.18	1	< 0.1%
0.24	1	< 0.1%
0.27	1	< 0.1%
0.31	1	< 0.1%
0.33	1	< 0.1%
0.34	2	< 0.1%
0.35	2	< 0.1%
0.36	6	< 0.1%

Value	Count	Frequency (%)
599.31	5	< 0.1%
585.62	1	< 0.1%
562.13	1	< 0.1%
552.9	1	< 0.1%
548.41	1	< 0.1%
439.67	1	< 0.1%
434.04	1	< 0.1%
407.98	1	< 0.1%
407.97	9	0.1%
406.45	1	< 0.1%

forecast_price_energy_off_peak
Real number (ℝ)

Distinct	516
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13728327

Minimum	0
Maximum	0.273963
Zeros	22
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0.11293
Q1	0.11634
median	0.143166
Q3	0.146348
95-th percentile	0.166178
Maximum	0.273963
Range	0.273963
Interquartile range (IQR)	0.030008

Descriptive statistics

Standard deviation	0.024622862
Coefficient of variation (CV)	0.17935808
Kurtosis	8.3645386
Mean	0.13728327
Median Absolute Deviation (MAD)	0.019738
Skewness	-0.11958602
Sum	2005.1594
Variance	0.00060628535
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.145711	933	6.4%
0.144902	732	5.0%
0.115174	726	5.0%
0.146694	644	4.4%
0.115237	595	4.1%
0.11691	449	3.1%
0.1169	406	2.8%
0.146348	339	2.3%
0.143166	335	2.3%
0.116509	308	2.1%
Other values (506)	9139	62.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	22	0.2%
0.0006	66	0.5%
0.000901	6	< 0.1%
0.092453	73	0.5%
0.094486	1	< 0.1%
0.095022	2	< 0.1%
0.095061	1	< 0.1%
0.095558	1	< 0.1%
0.095919	1	< 0.1%
0.096095	1	< 0.1%

Value	Count	Frequency (%)
0.273963	18	0.1%
0.273957	2	< 0.1%
0.272981	21	0.1%
0.272972	1	< 0.1%
0.245926	8	0.1%
0.245347	6	< 0.1%
0.237776	11	0.1%
0.236794	4	< 0.1%
0.236291	3	< 0.1%
0.229272	34	0.2%

forecast_price_energy_peak
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	329
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.050490767

Minimum	0
Maximum	0.195975
Zeros	7021
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.084138
Q3	0.098837
95-th percentile	0.10175
Maximum	0.195975
Range	0.195975
Interquartile range (IQR)	0.098837

Descriptive statistics

Standard deviation	0.049036507
Coefficient of variation (CV)	0.97119751
Kurtosis	-1.8907547
Mean	0.050490767
Median Absolute Deviation (MAD)	0.0311955
Skewness	-0.014331428
Sum	737.46815
Variance	0.002404579
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7021	48.1%
0.098837	722	4.9%
0.100123	596	4.1%
0.100015	473	3.2%
0.100572	445	3.0%
0.101397	308	2.1%
0.103487	288	2.0%
0.087381	169	1.2%
0.086803	159	1.1%
0.099419	153	1.0%
Other values (319)	4272	29.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7021	48.1%
0.076592	1	< 0.1%
0.077124	1	< 0.1%
0.078125	1	< 0.1%
0.078641	2	< 0.1%
0.078859	1	< 0.1%
0.079221	2	< 0.1%
0.079281	2	< 0.1%
0.079771	1	< 0.1%
0.079799	1	< 0.1%

Value	Count	Frequency (%)
0.195975	1	< 0.1%
0.168092	6	< 0.1%
0.168032	7	< 0.1%
0.146676	8	0.1%
0.136336	59	0.4%
0.13608	1	< 0.1%
0.135761	5	< 0.1%
0.135732	35	0.2%
0.135182	3	< 0.1%
0.134604	2	< 0.1%

forecast_price_pow_off_peak
Real number (ℝ)

Distinct	41
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	43.130056

Minimum	0
Maximum	59.266378
Zeros	94
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	40.606701
Q1	40.606701
median	44.311378
Q3	44.311378
95-th percentile	46.305378
Maximum	59.266378
Range	59.266378
Interquartile range (IQR)	3.704677

Descriptive statistics

Standard deviation	4.4859882
Coefficient of variation (CV)	0.10401072
Kurtosis	54.708041
Mean	43.130056
Median Absolute Deviation (MAD)	0.9969996
Skewness	-4.998772
Sum	629957.59
Variance	20.12409
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
44.31137796	6933	47.5%
40.606701	4651	31.8%
45.80687796	697	4.8%
46.30537836	615	4.2%
45.30837756	419	2.9%
41.1052014	302	2.1%
40.9390266	237	1.6%
41.2713642	160	1.1%
58.99595196	118	0.8%
0	94	0.6%
Other values (31)	380	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	94	0.6%
35.55576792	1	< 0.1%
37.929294	2	< 0.1%
40.606701	4651	31.8%
40.728885	31	0.2%
40.9390266	237	1.6%
41.1052014	302	2.1%
41.1067014	1	< 0.1%
41.2713642	160	1.1%
41.2718682	1	< 0.1%

Value	Count	Frequency (%)
59.26637796	42	0.3%
59.17346796	76	0.5%
59.05128396	1	< 0.1%
58.99595196	118	0.8%
53.28437796	14	0.1%
47.80087836	8	0.1%
47.30687796	2	< 0.1%
47.30237796	10	0.1%
46.80687756	1	< 0.1%
46.80387756	6	< 0.1%

has_gas
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	14.4 KiB

False	11955
True	2651

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	11955	81.8%
True	2651	18.2%

imp_cons
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7752
Distinct (%)	53.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	152.7869

Minimum	0
Maximum	15042.79
Zeros	6169
Zeros (%)	42.2%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	37.395
Q3	193.98
95-th percentile	638.8175
Maximum	15042.79
Range	15042.79
Interquartile range (IQR)	193.98

Descriptive statistics

Standard deviation	341.36937
Coefficient of variation (CV)	2.2342843
Kurtosis	380.8937
Mean	152.7869
Median Absolute Deviation (MAD)	37.395
Skewness	13.198799
Sum	2231605.4
Variance	116533.04
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6169	42.2%
0.3	5	< 0.1%
0.1	5	< 0.1%
34.53	4	< 0.1%
26.26	4	< 0.1%
42.04	4	< 0.1%
126.6	4	< 0.1%
26.51	4	< 0.1%
117.18	4	< 0.1%
0.15	4	< 0.1%
Other values (7742)	8399	57.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6169	42.2%
0.06	1	< 0.1%
0.09	2	< 0.1%
0.1	5	< 0.1%
0.14	1	< 0.1%
0.15	4	< 0.1%
0.17	2	< 0.1%
0.24	1	< 0.1%
0.27	1	< 0.1%
0.28	2	< 0.1%

Value	Count	Frequency (%)
15042.79	1	< 0.1%
9682.89	1	< 0.1%
8732.6	1	< 0.1%
8254.16	1	< 0.1%
6787.12	1	< 0.1%
5836.49	1	< 0.1%
5343.76	1	< 0.1%
5311.97	1	< 0.1%
5019.25	1	< 0.1%
4925.36	1	< 0.1%

margin_gross_pow_ele
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2391
Distinct (%)	16.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.565121

Minimum	0
Maximum	374.64
Zeros	157
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	3.56
Q1	14.28
median	21.64
Q3	29.88
95-th percentile	51.72
Maximum	374.64
Range	374.64
Interquartile range (IQR)	15.6

Descriptive statistics

Standard deviation	20.231172
Coefficient of variation (CV)	0.82357305
Kurtosis	35.892607
Mean	24.565121
Median Absolute Deviation (MAD)	8.12
Skewness	4.4726321
Sum	358798.16
Variance	409.30031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26.04	258	1.8%
33.12	238	1.6%
29.76	170	1.2%
34.68	161	1.1%
0	157	1.1%
16.92	156	1.1%
23.76	156	1.1%
10.08	151	1.0%
19.2	141	1.0%
14.64	135	0.9%
Other values (2381)	12883	88.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	157	1.1%
0.03	1	< 0.1%
0.12	125	0.9%
0.24	16	0.1%
0.36	7	< 0.1%
0.48	1	< 0.1%
0.6	1	< 0.1%
0.64	7	< 0.1%
0.66	1	< 0.1%
0.68	3	< 0.1%

Value	Count	Frequency (%)
374.64	1	< 0.1%
314.76	1	< 0.1%
299.64	1	< 0.1%
248.64	1	< 0.1%
225.12	2	< 0.1%
224.89	1	< 0.1%
224.64	1	< 0.1%
219.88	1	< 0.1%
214.35	1	< 0.1%
214.14	1	< 0.1%

margin_net_pow_ele
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2391
Distinct (%)	16.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.562517

Minimum	0
Maximum	374.64
Zeros	157
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	3.56
Q1	14.28
median	21.64
Q3	29.88
95-th percentile	51.72
Maximum	374.64
Range	374.64
Interquartile range (IQR)	15.6

Descriptive statistics

Standard deviation	20.23028
Coefficient of variation (CV)	0.82362404
Kurtosis	35.901232
Mean	24.562517
Median Absolute Deviation (MAD)	8.12
Skewness	4.4733258
Sum	358760.13
Variance	409.26422
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26.04	258	1.8%
33.12	238	1.6%
29.76	170	1.2%
34.68	161	1.1%
0	157	1.1%
16.92	156	1.1%
23.76	156	1.1%
10.08	151	1.0%
19.2	141	1.0%
14.64	135	0.9%
Other values (2381)	12883	88.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	157	1.1%
0.03	1	< 0.1%
0.12	125	0.9%
0.24	16	0.1%
0.36	7	< 0.1%
0.48	1	< 0.1%
0.6	1	< 0.1%
0.64	7	< 0.1%
0.66	1	< 0.1%
0.68	3	< 0.1%

Value	Count	Frequency (%)
374.64	1	< 0.1%
314.76	1	< 0.1%
299.64	1	< 0.1%
248.64	1	< 0.1%
225.12	2	< 0.1%
224.89	1	< 0.1%
224.64	1	< 0.1%
219.88	1	< 0.1%
214.35	1	< 0.1%
214.14	1	< 0.1%

nb_prod_act
Real number (ℝ)

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2923456

Minimum	1
Maximum	32
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	32
Range	31
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.70977352
Coefficient of variation (CV)	0.54921339
Kurtosis	258.95725
Mean	1.2923456
Median Absolute Deviation (MAD)	0
Skewness	8.6368779
Sum	18876
Variance	0.50377845
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	11431	78.3%
2	2445	16.7%
3	523	3.6%
4	150	1.0%
5	31	0.2%
9	11	0.1%
6	8	0.1%
8	4	< 0.1%
10	2	< 0.1%
32	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11431	78.3%
2	2445	16.7%
3	523	3.6%
4	150	1.0%
5	31	0.2%
6	8	0.1%
8	4	< 0.1%
9	11	0.1%
10	2	< 0.1%
32	1	< 0.1%

Value	Count	Frequency (%)
32	1	< 0.1%
10	2	< 0.1%
9	11	0.1%
8	4	< 0.1%
6	8	0.1%
5	31	0.2%
4	150	1.0%
3	523	3.6%
2	2445	16.7%
1	11431	78.3%

net_margin
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	11965
Distinct (%)	81.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	189.26452

Minimum	0
Maximum	24570.65
Zeros	185
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	0
5-th percentile	11.16
Q1	50.7125
median	112.53
Q3	243.0975
95-th percentile	587.685
Maximum	24570.65
Range	24570.65
Interquartile range (IQR)	192.385

Descriptive statistics

Standard deviation	311.79813
Coefficient of variation (CV)	1.6474198
Kurtosis	2642.9653
Mean	189.26452
Median Absolute Deviation (MAD)	75.32
Skewness	36.569515
Sum	2764397.6
Variance	97218.074
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	185	1.3%
0.49	6	< 0.1%
35.98	5	< 0.1%
57.37	5	< 0.1%
86.52	5	< 0.1%
56.33	5	< 0.1%
0.01	5	< 0.1%
234.83	4	< 0.1%
78.22	4	< 0.1%
33.8	4	< 0.1%
Other values (11955)	14378	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	185	1.3%
0.01	5	< 0.1%
0.02	4	< 0.1%
0.03	3	< 0.1%
0.04	3	< 0.1%
0.05	3	< 0.1%
0.06	1	< 0.1%
0.07	1	< 0.1%
0.08	1	< 0.1%
0.09	2	< 0.1%

Value	Count	Frequency (%)
24570.65	1	< 0.1%
10203.5	1	< 0.1%
4346.37	1	< 0.1%
4305.79	1	< 0.1%
3768.16	1	< 0.1%
3407.65	1	< 0.1%
3403.27	1	< 0.1%
3323.02	1	< 0.1%
3215.03	1	< 0.1%
2711.19	1	< 0.1%

num_years_antig
Real number (ℝ)

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.9978091

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	4
median	5
Q3	6
95-th percentile	7
Maximum	13
Range	12
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6117493
Coefficient of variation (CV)	0.32249116
Kurtosis	4.0781495
Mean	4.9978091
Median Absolute Deviation (MAD)	1
Skewness	1.4462138
Sum	72998
Variance	2.5977357
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
6	4769	32.7%
4	3982	27.3%
3	2433	16.7%
5	2317	15.9%
7	509	3.5%
11	185	1.3%
12	110	0.8%
8	103	0.7%
9	92	0.6%
10	81	0.6%
Other values (3)	25	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	11	0.1%
3	2433	16.7%
4	3982	27.3%
5	2317	15.9%
6	4769	32.7%
7	509	3.5%
8	103	0.7%
9	92	0.6%
10	81	0.6%

Value	Count	Frequency (%)
13	13	0.1%
12	110	0.8%
11	185	1.3%
10	81	0.6%
9	92	0.6%
8	103	0.7%
7	509	3.5%
6	4769	32.7%
5	2317	15.9%
4	3982	27.3%

origin_up
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1788991

Minimum	0
Maximum	5
Zeros	64
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	57.2 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	3
Q3	4
95-th percentile	4
Maximum	5
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.88780149
Coefficient of variation (CV)	0.27927955
Kurtosis	-1.0045517
Mean	3.1788991
Median Absolute Deviation (MAD)	1
Skewness	-0.5068071
Sum	46431
Variance	0.78819149
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
4	7097	48.6%
2	4294	29.4%
3	3148	21.6%
0	64	0.4%
5	2	< 0.1%
1	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	64	0.4%
1	1	< 0.1%
2	4294	29.4%
3	3148	21.6%
4	7097	48.6%
5	2	< 0.1%

Value	Count	Frequency (%)
5	2	< 0.1%
4	7097	48.6%
3	3148	21.6%
2	4294	29.4%
1	1	< 0.1%
0	64	0.4%

pow_max
Real number (ℝ)

Distinct	698
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.135136

Minimum	3.3
Maximum	320
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	3.3
5-th percentile	10.39
Q1	12.5
median	13.856
Q3	19.1725
95-th percentile	41.5
Maximum	320
Range	316.7
Interquartile range (IQR)	6.6725

Descriptive statistics

Standard deviation	13.534743
Coefficient of variation (CV)	0.74632711
Kurtosis	59.202563
Mean	18.135136
Median Absolute Deviation (MAD)	3.056
Skewness	5.7867849
Sum	264881.79
Variance	183.18928
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.2	2124	14.5%
10.392	2000	13.7%
13.856	1504	10.3%
15	583	4.0%
10.35	480	3.3%
19.8	416	2.8%
16.5	405	2.8%
20	294	2.0%
12.5	269	1.8%
13.15	234	1.6%
Other values (688)	6297	43.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.3	3	< 0.1%
3.464	1	< 0.1%
4	1	< 0.1%
5	2	< 0.1%
5.196	2	< 0.1%
5.75	2	< 0.1%
6	2	< 0.1%
6.9	1	< 0.1%
6.928	4	< 0.1%
7.7	1	< 0.1%

Value	Count	Frequency (%)
320	1	< 0.1%
260	1	< 0.1%
200	4	< 0.1%
192	1	< 0.1%
180	2	< 0.1%
166	1	< 0.1%
164	1	< 0.1%
160	2	< 0.1%
155.88	1	< 0.1%
155	3	< 0.1%

churn
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	827.4 KiB

0	13187
1	1419

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	14606
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Most occurring characters

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	14606	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	14606	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14606	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	13187	90.3%
1	1419	9.7%

start_year
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2010.5775

Minimum	2003
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	114.2 KiB

Quantile statistics

Minimum	2003
5-th percentile	2009
Q1	2010
median	2011
Q3	2012
95-th percentile	2013
Maximum	2014
Range	11
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6532678
Coefficient of variation (CV)	0.00082228506
Kurtosis	3.2281209
Mean	2010.5775
Median Absolute Deviation (MAD)	1
Skewness	-1.2368333
Sum	29366495
Variance	2.7332946
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
2012	3704	25.4%
2010	3609	24.7%
2011	2758	18.9%
2009	2690	18.4%
2013	1224	8.4%
2005	189	1.3%
2004	137	0.9%
2008	124	0.8%
2007	95	0.7%
2003	39	0.3%
Other values (2)	37	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2003	39	0.3%
2004	137	0.9%
2005	189	1.3%
2006	36	0.2%
2007	95	0.7%
2008	124	0.8%
2009	2690	18.4%
2010	3609	24.7%
2011	2758	18.9%
2012	3704	25.4%

Value	Count	Frequency (%)
2014	1	< 0.1%
2013	1224	8.4%
2012	3704	25.4%
2011	2758	18.9%
2010	3609	24.7%
2009	2690	18.4%
2008	124	0.8%
2007	95	0.7%
2006	36	0.2%
2005	189	1.3%

end_year
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	870.2 KiB

2016	13663
2017	943

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	58424
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2016
2nd row	2016
3rd row	2016
4th row	2016
5th row	2016

Common Values

Value	Count	Frequency (%)
2016	13663	93.5%
2017	943	6.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016	13663	93.5%
2017	943	6.5%

Most occurring characters

Value	Count	Frequency (%)
2	14606	25.0%
0	14606	25.0%
1	14606	25.0%
6	13663	23.4%
7	943	1.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	58424	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	14606	25.0%
0	14606	25.0%
1	14606	25.0%
6	13663	23.4%
7	943	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	58424	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	14606	25.0%
0	14606	25.0%
1	14606	25.0%
6	13663	23.4%
7	943	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	58424	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	14606	25.0%
0	14606	25.0%
1	14606	25.0%
6	13663	23.4%
7	943	1.6%

Auto

Heatmap
Table

	channel_sales	cons_12m	cons_gas_12m	cons_last_month	forecast_cons_12m	forecast_cons_year	forecast_discount_energy	forecast_meter_rent_12m	forecast_price_energy_off_peak	forecast_price_energy_peak	forecast_price_pow_off_peak	imp_cons	margin_gross_pow_ele	margin_net_pow_ele	nb_prod_act	net_margin	num_years_antig	origin_up	pow_max	start_year	has_gas	churn	end_year
channel_sales	1.000	0.089	-0.011	0.081	0.061	0.018	0.024	-0.017	0.066	0.002	0.006	0.029	0.030	0.030	-0.010	0.052	-0.399	0.150	-0.014	0.412	0.053	0.081	0.021
cons_12m	0.089	1.000	0.161	0.707	0.695	0.429	-0.024	0.288	-0.286	0.323	-0.364	0.411	-0.094	-0.094	0.119	0.688	-0.010	0.016	0.350	0.032	0.234	0.049	0.062
cons_gas_12m	-0.011	0.161	1.000	0.148	0.137	0.091	0.005	0.058	-0.048	0.065	-0.075	0.093	-0.026	-0.026	0.865	0.134	-0.002	0.001	0.076	0.005	0.302	0.037	0.058
cons_last_month	0.081	0.707	0.148	1.000	0.443	0.771	-0.018	0.351	-0.284	0.377	-0.370	0.759	-0.002	-0.002	0.109	0.445	0.009	0.033	0.351	0.022	0.231	0.041	0.055
forecast_cons_12m	0.061	0.695	0.137	0.443	1.000	0.508	0.052	0.258	-0.249	0.267	-0.325	0.515	-0.175	-0.175	0.125	0.950	-0.060	0.063	0.340	0.071	0.025	0.019	0.039
forecast_cons_year	0.018	0.429	0.091	0.771	0.508	1.000	0.014	0.426	-0.371	0.435	-0.444	0.987	-0.011	-0.011	0.072	0.516	-0.013	0.093	0.425	0.031	0.000	0.000	0.037
forecast_discount_energy	0.024	-0.024	0.005	-0.018	0.052	0.014	1.000	-0.003	0.275	0.090	0.149	0.033	0.241	0.240	0.144	0.018	-0.083	0.079	0.003	0.093	0.019	0.023	0.026
forecast_meter_rent_12m	-0.017	0.288	0.058	0.351	0.258	0.426	-0.003	1.000	-0.608	0.690	-0.625	0.397	0.116	0.116	0.034	0.293	0.006	0.054	0.660	0.000	0.058	0.042	0.045
forecast_price_energy_off_peak	0.066	-0.286	-0.048	-0.284	-0.249	-0.371	0.275	-0.608	1.000	-0.470	0.714	-0.321	0.041	0.041	0.012	-0.325	-0.035	-0.109	-0.670	0.053	0.068	0.050	0.136
forecast_price_energy_peak	0.002	0.323	0.065	0.377	0.267	0.435	0.090	0.690	-0.470	1.000	-0.731	0.400	0.176	0.176	0.065	0.326	-0.017	0.027	0.706	0.021	0.061	0.041	0.000
forecast_price_pow_off_peak	0.006	-0.364	-0.075	-0.370	-0.325	-0.444	0.149	-0.625	0.714	-0.731	1.000	-0.392	-0.139	-0.140	-0.030	-0.423	0.003	-0.090	-0.715	-0.053	0.069	0.055	0.129
imp_cons	0.029	0.411	0.093	0.759	0.515	0.987	0.033	0.397	-0.321	0.400	-0.392	1.000	-0.017	-0.017	0.077	0.501	-0.029	0.094	0.387	0.047	0.021	0.000	0.026
margin_gross_pow_ele	0.030	-0.094	-0.026	-0.002	-0.175	-0.011	0.241	0.116	0.041	0.176	-0.139	-0.017	1.000	1.000	-0.001	-0.119	-0.041	0.063	0.263	0.189	0.019	0.089	0.109
margin_net_pow_ele	0.030	-0.094	-0.026	-0.002	-0.175	-0.011	0.240	0.116	0.041	0.176	-0.140	-0.017	1.000	1.000	-0.001	-0.119	-0.041	0.063	0.263	0.189	0.019	0.089	0.109
nb_prod_act	-0.010	0.119	0.865	0.109	0.125	0.072	0.144	0.034	0.012	0.065	-0.030	0.077	-0.001	-0.001	1.000	0.108	-0.013	0.017	0.048	0.014	0.115	0.000	0.031
net_margin	0.052	0.688	0.134	0.445	0.950	0.516	0.018	0.293	-0.325	0.326	-0.423	0.501	-0.119	-0.119	0.108	1.000	-0.056	0.086	0.406	0.077	0.017	0.027	0.000
num_years_antig	-0.399	-0.010	-0.002	0.009	-0.060	-0.013	-0.083	0.006	-0.035	-0.017	0.003	-0.029	-0.041	-0.041	-0.013	-0.056	1.000	-0.414	-0.026	-0.933	0.043	0.087	0.151
origin_up	0.150	0.016	0.001	0.033	0.063	0.093	0.079	0.054	-0.109	0.027	-0.090	0.094	0.063	0.063	0.017	0.086	-0.414	1.000	0.114	0.428	0.002	0.097	0.010
pow_max	-0.014	0.350	0.076	0.351	0.340	0.425	0.003	0.660	-0.670	0.706	-0.715	0.387	0.263	0.263	0.048	0.406	-0.026	0.114	1.000	0.032	0.030	0.026	0.010
start_year	0.412	0.032	0.005	0.022	0.071	0.031	0.093	0.000	0.053	0.021	-0.053	0.047	0.189	0.189	0.014	0.077	-0.933	0.428	0.032	1.000	0.057	0.089	0.198
has_gas	0.053	0.234	0.302	0.231	0.025	0.000	0.019	0.058	0.068	0.061	0.069	0.021	0.019	0.019	0.115	0.017	0.043	0.002	0.030	0.057	1.000	0.023	0.000
churn	0.081	0.049	0.037	0.041	0.019	0.000	0.023	0.042	0.050	0.041	0.055	0.000	0.089	0.089	0.000	0.027	0.087	0.097	0.026	0.089	0.023	1.000	0.001
end_year	0.021	0.062	0.058	0.055	0.039	0.037	0.026	0.045	0.136	0.000	0.129	0.026	0.109	0.109	0.031	0.000	0.151	0.010	0.010	0.198	0.000	0.001	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	channel_sales	cons_12m	cons_gas_12m	cons_last_month	date_activ	date_end	date_modif_prod	date_renewal	forecast_cons_12m	forecast_cons_year	forecast_meter_rent_12m	forecast_price_energy_off_peak	forecast_price_energy_peak	forecast_price_pow_off_peak	has_gas	imp_cons	margin_gross_pow_ele	margin_net_pow_ele	nb_prod_act	net_margin	num_years_antig	origin_up	pow_max	churn	start_year	end_year
0	24011ae4ebbe3035111d65fa7c15bc57	4	0	54946	0	2013-06-15	2016-06-15	2015-11-01	2015-06-23	0.00	0	1.78	0.114481	0.098142	40.606701	t	0.00	25.44	25.44	2	678.99	3	4	43.648	1	2013	2016
1	d29c2c54acc38ff3c0614d0a653813dd	0	4660	0	0	2009-08-21	2016-08-30	2009-08-21	2015-08-31	189.95	0	16.27	0.145711	0.000000	44.311378	f	0.00	16.38	16.38	1	18.89	6	2	13.800	0	2009	2016
2	764c75f661154dac3a6c254cd082ea7d	4	544	0	0	2010-04-16	2016-04-16	2010-04-16	2015-04-17	47.96	0	38.72	0.165794	0.087899	44.311378	f	0.00	28.60	28.60	1	6.60	6	2	13.856	0	2010	2016
3	bba03439a292a1e166f80264c16191cb	5	1584	0	0	2010-03-30	2016-03-30	2010-03-30	2015-03-31	240.04	0	19.83	0.146694	0.000000	44.311378	f	0.00	30.22	30.22	1	25.46	6	2	13.200	0	2010	2016
4	149d57cf92fc41cf94415803a877cb4b	0	4425	0	526	2010-01-13	2016-03-07	2010-01-13	2015-03-09	445.75	526	131.73	0.116900	0.100015	40.606701	f	52.32	44.91	44.91	1	47.98	6	2	19.800	0	2010	2016
5	1aa498825382410b098937d65c4ec26d	7	8302	0	1998	2011-12-09	2016-12-09	2015-11-01	2015-12-10	796.94	1998	30.12	0.164775	0.086131	45.308378	f	181.21	33.12	33.12	1	118.89	4	4	13.200	1	2011	2016
6	7ab4bf4878d8f7661dfc20e9b8e18011	4	45097	0	0	2011-12-02	2016-12-02	2011-12-02	2015-12-03	8069.28	0	0.00	0.166178	0.087538	44.311378	f	0.00	4.04	4.04	1	346.63	4	4	15.000	1	2011	2016
7	01495c955be7ec5e7f3203406785aae0	4	29552	0	1260	2010-04-21	2016-04-21	2010-04-21	2015-04-22	864.73	751	144.49	0.115174	0.098837	40.606701	f	70.63	53.92	53.92	1	100.09	6	4	26.400	0	2010	2016
8	f53a254b1115634330c12c7fdbf7958a	7	2962	0	0	2011-09-23	2016-09-23	2011-09-23	2015-09-25	444.38	0	15.85	0.145711	0.000000	44.311378	f	0.00	12.82	12.82	1	42.59	4	2	13.200	0	2011	2016
9	10c1b2f97a2d2a6f10299dc213d1a370	5	26064	0	2188	2010-05-04	2016-05-04	2015-04-29	2015-05-05	2738.10	2188	130.43	0.115761	0.099419	40.606701	f	219.59	33.42	33.42	1	329.60	6	4	31.500	0	2010	2016

	id	channel_sales	cons_12m	cons_gas_12m	cons_last_month	date_activ	date_end	date_modif_prod	date_renewal	forecast_cons_12m	forecast_cons_year	forecast_meter_rent_12m	forecast_price_energy_off_peak	forecast_price_energy_peak	forecast_price_pow_off_peak	has_gas	imp_cons	margin_gross_pow_ele	margin_net_pow_ele	nb_prod_act	net_margin	num_years_antig	origin_up	pow_max	churn	start_year	end_year
14596	c3f4f737d598a1b47a94440bb18c3c06	5	1097	0	0	2011-02-09	2016-02-09	2011-02-09	2015-02-11	165.60	0	16.04	0.146694	0.000000	44.311378	f	0.00	26.04	26.04	1	17.38	5	3	10.392	0	2011	2016
14597	ae818f3cc00ef5845416699aacc4bd7e	2	8310	0	685	2012-12-18	2016-12-18	2012-12-18	2015-12-21	833.05	685	131.76	0.115237	0.100123	40.939027	f	67.03	24.02	24.02	1	102.52	3	2	23.100	0	2012	2016
14598	1582ef35fbfa265e60bb3399bdebac87	0	9441	0	480	2009-10-08	2016-10-08	2015-05-24	2015-10-09	983.97	480	132.11	0.115237	0.100123	40.939027	f	46.98	20.00	20.00	1	113.17	6	3	15.001	0	2009	2016
14599	46362cb1ad2fcdad347a6fa1bc1e5d4b	4	18163	3036	0	2010-01-26	2017-01-26	2015-11-17	2016-01-27	2663.82	0	16.35	0.143575	0.000000	44.311378	t	0.00	31.20	31.20	3	254.81	6	2	13.856	0	2010	2017
14600	c49217f16a06263e5381eaba94a67a8b	4	87146	0	11367	2013-02-08	2016-02-08	2013-02-08	2015-02-09	712.33	713	145.82	0.120372	0.103487	40.606701	f	71.81	66.00	66.00	1	87.14	3	4	26.400	0	2013	2016
14601	18463073fb097fc0ac5d3e040f356987	4	32270	47940	0	2012-05-24	2016-05-08	2015-05-08	2014-05-26	4648.01	0	18.57	0.138305	0.000000	44.311378	t	0.00	27.88	27.88	2	381.77	4	4	15.000	0	2012	2016
14602	d0a6f71671571ed83b2645d23af6de00	4	7223	0	181	2012-08-27	2016-08-27	2012-08-27	2015-08-28	631.69	181	144.03	0.100167	0.091892	58.995952	f	15.94	0.00	0.00	1	90.34	3	4	6.000	1	2012	2016
14603	10e6828ddd62cbcf687cb74928c4c2d2	4	1844	0	179	2012-02-08	2016-02-07	2012-02-08	2015-02-09	190.39	179	129.60	0.116900	0.100015	40.606701	f	18.05	39.84	39.84	1	20.38	4	4	15.935	1	2012	2016
14604	1cf20fd6206d7678d5bcafd28c53b4db	4	131	0	0	2012-08-30	2016-08-30	2012-08-30	2015-08-31	19.34	0	7.18	0.145711	0.000000	44.311378	f	0.00	13.08	13.08	1	0.96	3	4	11.000	0	2012	2016
14605	563dde550fd624d7352f3de77c0cdfcd	0	8730	0	0	2009-12-18	2016-12-17	2009-12-18	2015-12-21	762.41	0	1.07	0.167086	0.088454	45.311378	f	0.00	11.84	11.84	1	96.34	6	3	10.392	0	2009	2016

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample